use "C:\Country Change Indicators"
keep country year q cpd
keep if year<2011
bysort year q: egen tcpd=total(cpd)
gen z=100*cpd/tcpd
gen styear=string(year)
gen stq=string(q)
gen yq=styear+stq
format z %5.1f
gen c=cpd
keep country yq c z
reshape wide c z, i(country) j(yq) string

*** Table 4

outsheet country z* c* using "C:\Country Clearing Table", replace

